#!/bin/bash

#	顾凯  --- card
#	| dev_ora_card       |
#	| ora_card           |
#	
#	伟娜   --- orange
#	| orangedb           |
#	| orangedb_pro       |
#	
#	李光辉  --- python
#	| django_db2         |
#	
#	杨鹤   --- java
#	ora_tour
#	orabot
#	ora_explore
#	 
#	邵辉辉   orapay
#	| bankcard           |
#	| wechat_pay         |

root="/data/backup/database/"
passwd="O3r5a8ex"
db_host="rm-2zej60958x95x427y.mysql.rds.aliyuncs.com"
date_time=`date  "+%Y%m%d"`

#顾凯  --- card
mysqldump -u root -p${passwd} -h${db_host} dev_ora_card > ${root}/card/dev_ora_card_${date_time}.sql
mysqldump -u root -p${passwd} -h${db_host} ora_card > ${root}/card/ora_card_${date_time}.sql

#伟娜   --- orange
mysqldump -u root -p${passwd} -h${db_host} orangedb > ${root}/orange/orangedb_${date_time}.sql
mysqldump -u root -p${passwd} -h${db_host} orangedb_pro > ${root}/orange/orangedb_pro_${date_time}.sql


#李光辉  --- python
mysqldump -u root -p${passwd} -h${db_host} django_db2 > ${root}/python/django_db2_${date_time}.sql

#杨鹤   --- java
mysqldump -u root -p${passwd} -h${db_host} ora_tour > ${root}/java/ora_tour_${date_time}.sql
mysqldump -u root -p${passwd} -h${db_host} orabot > ${root}/java/orabot_${date_time}.sql
mysqldump -u root -p${passwd} -h${db_host} ora_explore > ${root}/java/ora_explore_${date_time}.sql

#邵辉辉 ---  orapay
mysqldump -u root -p${passwd} -h${db_host} bankcard > ${root}/orapay/bankcard_${date_time}.sql
mysqldump -u root -p${passwd} -h${db_host} wechat_pay > ${root}/orapay/wechat_pay_${date_time}.sql

